﻿<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<!-- saved from url=(0029)http://www.helpandmanual.com/ -->
<head> 
   <!-- Premium Pack Version 1.24 Template design (c) copyright 2008-2009 by Tim Green and EC Software -->
   <title>Dynamic and Manual Entry Queries</title> 
   <meta name="generator" content="Help &amp; Manual" /> 
   <meta name="keywords" content="" />
   <meta name="description" content="Dynamic and Manual Entry Queries" />
   <meta name="copyright" content="© 2012 Futures Group" /> 
   <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />                                         
   <link type="text/css" href="default.css" rel="stylesheet" />
   <link type="text/css" href="custom.css" rel="stylesheet" />
   <script type="text/javascript" src="jquery-1.3.2.min.js"></script>
   <script type="text/javascript" src="jquery.scrollTo-min.js"></script>
   <script type="text/javascript" src="nsh.js"></script>

<script type="text/javascript">

</script>



<style type="text/css">
   .help-url { font-size: 8pt; font-family: Verdana, Helvetica, sans-serif; 
               color: #000; text-align: center; margin: 15px 20px 20px 0px; 
               padding-top: 5px; border-top: 1px solid #000;}
   .help-url a { color: #000; text-decoration: none; }
   .help-url a:visited { color: #000; }
   .help-url a:hover { color: #000; text-decoration: underline; }
   .highlight {background: #ffff40;}
</style>







<!-- CSS set with project variables and local attributes --> 
<style type="text/css" media="screen"> 
   body { background: #fff; } 
   #breadcrumbs { width: 100%; background-color: white; border: 1px solid #000; padding: 2px 0 1px 2px;
   margin: 3px 0; font-size: 8pt; color: #000;}
   #breadcrumbs a { color: #000; text-decoration: none;}
   #breadcrumbs a:visited { color: #000; }
   #breadcrumbs a:hover { color: #098ae2; text-decoration: none; }
</style> 

<!-- Adjustment for IE -->
<!--[if lte IE 8]>
<style type="text/css">
.topichead { padding-right: 0; }
#autoTocWrapper ul li { padding: 3px 3px 4px 3px;}

   .breadhead {
   margin: 0;
   padding-right: 5px;
   }
   img#togtoc {
       bottom:1px; 
    }   

   
</style>
<![endif]-->
   
<script type="text/javascript">
// Initialize the page 
addEvent(window, "load", nsrInit);
addEvent(window, "load", doResize);
addEvent(window, "resize", doResize);
if (!$.browser.msie) {
addEvent(window, "load", toggleJump);
}
</script>

<script type="text/javascript" src="helpman_topicinit.js"></script>
<!-- Redirect browser to frame page if page is not in the content frame. -->
<script type="text/javascript">
<!--
if (location.search.lastIndexOf("toc=0")<=0) {
  if (parent.frames.length==0) { parent.location.href="index.html?dynamic_and_manual_entry_queries.htm"; }
  else { parent.quicksync('a7.2'); }
}
//-->
</script>
<script type="text/javascript" src="highlight.js"></script></head> 
<body onload="highlight();">
<div id="hmpopupDiv" style="visibility:hidden; position:absolute; z-index:1000; "></div>
<!--ZOOMSTOP-->

<div id="printheader">
<span id="printtitle">IQCare User Guide V3.2</span><br />
<p class="p_Heading1"><span class="f_Heading1">Dynamic and Manual Entry Queries</span></p>
</div>
<div id="idheader" style= "background: #a7d7f8 url('bg_topichd.gif') repeat-x bottom;"> 
<table id="breadtable" width="100%" border="0" cellspacing="0" cellpadding="0"> 
  <tr >
  <td align="left" class="breadhead" height="5">
        
  </td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="headtable"> 

<!-- Script version of NavHeader -->
<tr id="scriptNavHead" valign="middle" style="height: auto;">
   
   <td align="left" class="topichead">
   <p class="p_Heading1"><span class="f_Heading1">Dynamic and Manual Entry Queries</span></p>

   </td>
   
   <td align="center" width="20" class="idnav" valign="bottom">
     <a href="filtering_patient_location_and_treatment_loc.htm"
        onmouseover="document.images.prev.src='button_prev_h.gif'" 
        onmouseout="document.images.prev.src='button_prev.gif'">
        <img name="prev" src="button_prev.gif" border="0" alt="Previous topic" title="Previous topic" /></a>
     
   </td>
   
   <td align="center" width="20" class="idnav" valign="bottom">
     <a href="custom_report_functions.htm"
        onmouseover="document.images.next.src='button_next_h.gif'" 
        onmouseout="document.images.next.src='button_next.gif'"><img name="next" src="button_next.gif" border="0" alt="Next topic" title="Next topic" /></a>
        
   </td>
   
   
   
  
   <td width="4">&nbsp;</td>
  </tr>
<!-- End script navheader version -->

<!-- NoScript version of navheader -->
  <tr id="noScriptNavHead" valign="middle" style="height: auto;"> 
    <td align="left" class="topichead"> 
    <p class="p_Heading1"><span class="f_Heading1">Dynamic and Manual Entry Queries</span></p>

    </td>
    <td align="center" width="20" class="idnav" valign="bottom">
     <a href="filtering_patient_location_and_treatment_loc.htm">
        <img src="button_prev.gif" border="0" alt="Previous topic" title="Previous topic" /></a>
     
   </td>
   <td align="center" width="20" class="idnav" valign="bottom">
     <a href="custom_report_functions.htm">
        <img src="button_next.gif" border="0" alt="Next topic" title="Next topic" /></a>
        
   </td>
   
   
   
   
   <td width="4">&nbsp;</td>
  </tr>
<!-- End noscript navheader version -->
  </table>
<div id="autoTocWrapper"></div>
</div> 

<div id="idcontent"><div id="innerdiv">
<!--ZOOMRESTART-->
<p>An SQL query is the abbreviation for <span style="font-weight: bold;">S</span><span style="font-style: italic;">tructured </span><span style="font-style: italic; font-weight: bold;">Q</span><span style="font-style: italic;">uery </span><span style="font-style: italic; font-weight: bold;">L</span><span style="font-style: italic;">anguage</span>, and is pronounced either see-kwell or as separate letters. SQL is a standardized query language for requesting information from a database. IQCare uses SQL to request data from the database in order to create Custom Reports. The Custom Reports feature of IQCare provides a tool for you to create SQL dynamically or “on the fly”. By selecting the field groupings and fields along with the filters and functions, you direct IQCare to generate a complex SQL statement that pulls the correct data in the requested format into a report. This SQL can be seen at the bottom of the Custom Reports configuration page. Note that as you add fields and functions, the SQL builds and the statement gets larger. </p>
<p>&nbsp;</p>
<p><img id="$TOGGLE0186A1_ICON" src="hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="AR Forms" title="AR Forms"> &nbsp; &nbsp; &nbsp; &nbsp;<a class="dropdown-toggle" title="AR Forms" href="javascript:HMToggle('toggle','TOGGLE0186A1','$TOGGLE0186A1_ICON')">Dynamic Query Mode</a> </p>
<div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 10px;"><table id="TOGGLE0186A1" cellspacing="0" cellpadding="2" border="0" style="border: none; border-spacing:0px; border-collapse: collapse;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top" style="border: solid 1px #000000;"><p>In Dynamic Query mode the dynamic report configuration is enabled and the advanced query option where you can type SQL is disabled. </p>
<p>&nbsp;</p>
<p><img src="customreportdynamicquery.png" width="673" height="435" border="0" alt="CustomReportDynamicQuery"></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</td>
</tr>
</table>
</div>
<p>&nbsp;</p>
<p><img id="$TOGGLE0186A2_ICON" src="hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="AR Forms" title="AR Forms"> &nbsp; &nbsp; &nbsp; &nbsp;<a class="dropdown-toggle" title="AR Forms" href="javascript:HMToggle('toggle','TOGGLE0186A2','$TOGGLE0186A2_ICON')">Type SQL Mode</a></p>
<div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 10px;"><table id="TOGGLE0186A2" cellspacing="0" cellpadding="2" border="0" style="border: none; border-spacing:0px; border-collapse: collapse;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top" style="border: solid 1px #000000;"><p>Sometimes, the reports you want to create can not be generated using the dynamic SQL feature in IQCare. In that case, you can use the Type SQL option and simply type or cut and paste the SQL statement you want run,into the box provided at the end of the Custom Report configuration page. In Type SQL mode the dynamic report configuration is disabled and the advanced query option where you can type SQL is enabled.</p>
<p>&nbsp;</p>
<p><img src="customreporttypesql.png" width="673" height="430" border="0" alt="CustomReportTypeSQL"></p>
<p>&nbsp;</p>
</td>
</tr>
</table>
</div>
<p>&nbsp;</p>

<!--ZOOMSTOP--> 

</div></div> 
<script type="text/javascript">
HMInitToggle('$TOGGLE0186A1_ICON','hm.type','dropdown','hm.state','0','hm.src0','hmtoggle_arrow0.gif','hm.src1','hmtoggle_arrow1.gif','onclick','HMToggle(\'toggle\',\'TOGGLE0186A1\',\'\$TOGGLE0186A1_ICON\')');
HMInitToggle('TOGGLE0186A1','hm.type','dropdown','hm.state','0');
HMInitToggle('$TOGGLE0186A2_ICON','hm.type','dropdown','hm.state','0','hm.src0','hmtoggle_arrow0.gif','hm.src1','hmtoggle_arrow1.gif','onclick','HMToggle(\'toggle\',\'TOGGLE0186A2\',\'\$TOGGLE0186A2_ICON\')');
HMInitToggle('TOGGLE0186A2','hm.type','dropdown','hm.state','0');
</script>
</body>
<!--[if IE]>
<script type="text/javascript" defer="defer">
$("#hmcontent",window.parent.document).ready(function() {
var doTogJump=setTimeout("toggleJump()", 0);
      });
</script>
<![endif]-->
</html>
